Tabela POZDeclarationReport

Definicja tabeli POZDeclarationReport

Name

POZDeclarationReport

Code

POZDeclarationReport

Comment

 


Lista kolumn tabeli POZDeclarationReport

Name

Code

POZDeclarationReportID

POZDeclarationReportID

MessageID

MessageID

ContractNo

ContractNo

Year

Year

Month

Month

Category

Category

DeclarationScope

DeclarationScope

Version

Version

VerificationID

VerificationID

VerificationDT

VerificationDT

VerificationScope

VerificationScope

POZDeclarationReportNFZID

POZDeclarationReportNFZID

DeclarationType

DeclarationType

ReportID

ReportID


Kolumna POZDeclarationReportID tabeli POZDeclarationReport

Definicja kolumny POZDeclarationReportID tabeli POZDeclarationReport

Name

POZDeclarationReportID

Code

POZDeclarationReportID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MessageID tabeli POZDeclarationReport

Definicja kolumny MessageID tabeli POZDeclarationReport

Name

MessageID

Code

MessageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractNo tabeli POZDeclarationReport

Definicja kolumny ContractNo tabeli POZDeclarationReport

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna Year tabeli POZDeclarationReport

Definicja kolumny Year tabeli POZDeclarationReport

Name

Year

Code

Year

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Month tabeli POZDeclarationReport

Definicja kolumny Month tabeli POZDeclarationReport

Name

Month

Code

Month

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Category tabeli POZDeclarationReport

Definicja kolumny Category tabeli POZDeclarationReport

Name

Category

Code

Category

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna DeclarationScope tabeli POZDeclarationReport

Definicja kolumny DeclarationScope tabeli POZDeclarationReport

Name

DeclarationScope

Code

DeclarationScope

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna Version tabeli POZDeclarationReport

Definicja kolumny Version tabeli POZDeclarationReport

Name

Version

Code

Version

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VerificationID tabeli POZDeclarationReport

Definicja kolumny VerificationID tabeli POZDeclarationReport

Name

VerificationID

Code

VerificationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VerificationDT tabeli POZDeclarationReport

Definicja kolumny VerificationDT tabeli POZDeclarationReport

Name

VerificationDT

Code

VerificationDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna VerificationScope tabeli POZDeclarationReport

Definicja kolumny VerificationScope tabeli POZDeclarationReport

Name

VerificationScope

Code

VerificationScope

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna POZDeclarationReportNFZID tabeli POZDeclarationReport

Definicja kolumny POZDeclarationReportNFZID tabeli POZDeclarationReport

Name

POZDeclarationReportNFZID

Code

POZDeclarationReportNFZID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DeclarationType tabeli POZDeclarationReport

Definicja kolumny DeclarationType tabeli POZDeclarationReport

Name

DeclarationType

Code

DeclarationType

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna ReportID tabeli POZDeclarationReport

Definicja kolumny ReportID tabeli POZDeclarationReport

Name

ReportID

Code

ReportID

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Lista kluczy tabeli POZDeclarationReport

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli POZDeclarationReport

Definicja klucza Identifier_1 tabeli POZDeclarationReport

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment